// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.

suite("test_ssl_stability") {
    def tbName = "tb_test_ssl_stability"
    int test_count = 5;
    while (test_count-- > 1) {
        sql "DROP TABLE IF EXISTS ${tbName}"
        // char not null to null
        sql """
            CREATE TABLE IF NOT EXISTS ${tbName} (
                k1 INT NOT NULL,
                value1 varchar(16) NOT NULL
            )
            DUPLICATE KEY (k1)
            DISTRIBUTED BY HASH(k1) BUCKETS 1 properties("replication_num" = "1");
        """
        StringBuilder insertCommand = new StringBuilder();
        insertCommand.append("INSERT INTO ${tbName} VALUES ");
        int insert_row_count = 100000;
        while (insert_row_count-- > 1) {
            insertCommand.append("(1, '11'),");
        }
        insertCommand.append("(1, '11')");
        sql insertCommand.toString()
    }
}
